class ReviseFighterColumn < ActiveRecord::Migration
  def change
    add_column    :fighters, :gender,    :string
    add_column    :fighters, :state,     :string
    
    add_column    :fighters, :skill_style_1,    :string
    add_column    :fighters, :skill_trained_1,  :integer
    add_column    :fighters, :skill_belt_1,     :string
    add_column    :fighters, :skill_style_2,    :string
    add_column    :fighters, :skill_trained_2,  :integer
    add_column    :fighters, :skill_belt_2,     :string
    add_column    :fighters, :skill_style_3,    :string
    add_column    :fighters, :skill_trained_3,  :integer
    add_column    :fighters, :skill_belt_3,     :string

    add_column    :fighters, :ladder_id,        :integer
    add_column    :fighters, :ladder_status,    :string,  :default => 'New'
    add_column    :fighters, :ladder_payment,   :integer
    add_column    :fighters, :ladder_due,       :datetime

    add_column    :fighters, :disclaim_accept,  :boolean, :default => 0, :null => false
    add_column    :fighters, :disclaim_signed,  :datetime

    change_column :fighters, :weight,    :string
    change_column :fighters, :height,    :string

    remove_column :fighters, :sex
    remove_column :fighters, :reach
  end
end
